Replace first word?

[Francis P.]

How could I replace the first word in a string?

Thanks.

[Lee Smith]

What is the reason you need to do this?

How about a hint to what the data looks like.

I could give you a couple of calculations that would do this, but if we knew what you were trying to accomplish and why, we can better fit the answer.

Lee

[Francis P.]

Well basically I have a price list with codes. I have an excel file with these codes but it has 1,2,3,4,5... before the code in other words code "x" would be "1 x" on the excel sheet. I need a function to replace the "1" before the x when importing.

Thanks.

[Lee Smith]

Try

RightWord (YourField; 1)

[bvo12585]

I would use something like this since there may be more than just two words in the string. This would result in "xyz product" for an input of "123 xyz product". Input would obviously be the value you're importing.

Let (

[

Input = "123 xyz product" ;

ReplaceSpaces = Substitute ( Input ; " " ; "¶" ) ;

FirstValue = GetValue ( ReplaceSpaces ; 1 ) ;

Output = Substitute ( Input ; FirstValue ; "" )

] ;

Trim ( Output )

)

[comment]

And this would result in "nails, 2 inch" for input of "1 nails, 12 inch".