How do I split a text value by the TAB Char

[Charles Swart]

Firstly I have very little BP experience, so excuse me if this is a silly question.

I have a text string that contains a tab ( hex/ascii value 09). I now need to split the string on the TAB.
I have tried the SplitStringInto function with chr(09) as the split value, but this does not work.

 

[Sukesh Kumaru]

Hello,

Use InStr() function.
you will get the position of tab and then
Use Mid() function provide the position as 1,x x=position returned by InStr() function.

Good Luck.

 

[otonx]

if BP accept regular expression to split string,

use \t as the split value

 

[mdhazlee]

There's an in-built VBO Utility Strings -> Extract Regex values to extract based on regular expressions. However, it will only extract the first match for the expression. So if you have multiple pattern matches, you'll need to do a code stage to output all the matches onto the collection. You can refer to the following link for the code to get multiple matches (you'll also need to learn some regular expressions as well to properly extract the matches)

https://www.rpaforum.net/threads/ho...x-values-action-of-utility-strings.681/page-2

 

[VJR]

Hi Charles,

A string with a TAB is split using the 'Split Text' action as shown below.
If you are not able to split it then make sure if it is really a TAB character or not.

Input Text:
View attachment 1537248318607.png


Split Text:
View attachment 1537248356611.png


Output collection after splitting:
View attachment 1537248397250.png

 

[Charles Swart]

Thank you for the feedback. Was able to resolve the problem.

 

[paolotormon]

Hi Charles,

A string with a TAB is split using the 'Split Text' action as shown below.
If you are not able to split it then make sure if it is really a TAB character or not.

Input Text:
View attachment 1940


Split Text:
View attachment 1941


Output collection after splitting:
View attachment 1942

Thank you!