String manipulation - help required

I have the following string:

“\n\t\t\t\t\t\t\tClient Information Details\n \n Client ID: RX80036\n Client Name: Nathan Jasik\n Client Country: Romania\n\t\t\t\t\t\t\t\t\n \n\t\t\t\t\t\t”

and in the need to get the:

Client ID,
Client Name, and
Client Country

any help would be highly appreciated

Thanks!

Something like Replace(Replace($STRING,’\t’,’’),’\n’,vbCrLf)) would give you:

Client Information Details

Client ID: RX80036
Client Name: Nathan Jasik
Client Country: Romania

Hi @mesalcan,

Hope this might be helpful to you!

cheers :smiley:

Happy learning :smiley:

2 Likes

@pattyricarte Yeah - even better; that’s what it comes down to - being proficient in all the string manipulation tools.

1 Like

Hi @sagacity

That’s great i hope we solve t he problem :smiley:

cheers :smiley:

Happy learning :smiley:

I have tried this “Replace(Replace($STRING,’\t’,’’),’\n’,vbCrLf))” and I am getting the error “Expression expected”

Thanks!

@mesalcan - Sorry. That was pseudo code meaning to give you an idea how to approach. The exact (except the input string, which you need to supply) would be:

inString.Replace("\t","").Replace("\n",vbnewline)

@sagacity - Thanks, I was using vbCrLf instead of vbnewline. I am not getting the error anymore; but it is still not working as you can see:

Here is the value of ClientName

Thanks!

Hello mesalcan,
Try This Solution. It will be quite easy:Main.xaml (8.0 KB)

Please let me know whether it works for you or not.

1 Like

Thanks, it worked, and I can see why.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.