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


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:


@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”


@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:


@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


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.