Using only the first two words of a field value

[#1]

Hi everyone, I have a spreadsheet with the heading Description. This is a list of details of regular repeating information i.e bank payment is this, someone paid you that, bank payment is something. So you can see that the first two words are always going to be quite similar every time.

Is it possible to have te script look for only the first two words and discard the rest of the field? I know you can do something with finding the first space but this has got me stuck.

Many thanks.

[kaushiknsolanki]

Hi,

   So you want to skip the fields from spreadsheet or the data from particular field.

Regards

Kaushik Solanki

[nagaiank]

You may use the following script to skip the repeating string, if that is what you want.

Data:

LOAD *, Replace(Description,'bank payment is ','') as Newdescription;

LOAD * Inline [

Tnx, Description

1, bank payment is $200

2, bank payment is $100

3, bank payment is $500

];

[#4 · Accepted solution]

Hello Phil,

check this out: I assume you need the 'LeftText'-solution:

LOAD

    . . .

     Text,

    Left(Text, Index(Text,' ', 2))                AS LeftText

    Right(Text, Len(Text) - Index(Text,' ', 2)) AS RightText,

    TextBetween(Text,' ', ' ')                    AS BetwText,

.  . .

Regards,

Roland

[#5]

Hi Roland, thank you for this, its excellent! I will certainly be making use of the other examples.

[#6]

Hi Phil,

glad to help.

Roland