I am getting the following text from a third party API call. I am looking to extract only the credit card number and the cardholder name from it. How can I make this happen in Appian? Is there any function that could help?
"BBVARewards4000 1234 5678 901012/20VALIDTHRUVISAJOSE MARIA SANCHEZ"
Discussion posts and replies are publicly visible
As mike suggested you can use code like below
load( local!data: split( "BBVARewards4000 1234 5678 901012/20VALIDTHRUVISAJOSE MARIA SANCHEZ", char( 10 ) ), { cardNumber: local!data[3], name: local!data[8] })