Split text separated by space and tab

Hello,
I have a text file attached. what I want is to index the words, the problem is that each word can be separated from the other by space or several space or by tabulation.
the goal is to index them and put them in a new text file

Best regards,

@Manjuts90 @kaderms @nadim.warsi @beesheep

1 Like
  • Use Match Activity with pattern \d.
  • Use for each loop
  • Assign the required value
1 Like

a few example please.

Please check this.

test.xaml (6.7 KB)

1 Like

thanks a lot can you show me the scrren shot of your process , due to the version that I have i cant see the actvivities under the Match activity.

thank you,

See the below screenshot. And use the pattern “[a-z]+”

2 Likes

thank you

that work, but the problem I have is that there is some word like "TVA nature " must be in one words ?

any help on that case please

best regards,

Use this pattern “[a-z]+_[a-z]+”

thanks, I want to mention something the under scores between words just to design the number of space,

because I cant upload a text file on Forum uipath.

so the "_ " equals " "

1 Like

Then you can use “[a-z ]+” (Added space)

that not work, thanks anayway :slight_smile:

Then you can use “[a-z]+\s[a-z]+”

2 Likes

thanks man

1 Like

Your welcome :slightly_smiling_face:

Please mark the solution as solved.

hello @Vivek_Arunagiri,

I’ll do that but how am I going to cut this chain, because it exposes compound words, like “VAT nature” and other not, like “Amount” at the same time

thanks alot

1 Like

Okay… Got it… We need to use Question mark for Space.

[a-z]+\s?[a-z]+

1 Like

still have some words that contain " . " between like “Ana. key”

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