Add a char after each word

[Anuviel]

What would be the easiest way to add | after each word in a field?

The number of words will change time to time. I am looking either for the auto-enter calc that will do this or an output into a different field would also be ok.

Basically it is for keywords. The field will look something like

blue big bird fuzzy stuffed animal

After that is put into field I need to get this:

blue|big|bird|fuzzy|stuffed|animal

Not sure where to start, any help is appreciated.

Thank you kindly.,

[mr_vodka]

I guess you could use one field to enter the data ( perhaps a global field ) and another to log all the changes that uses an auto-update, but this may not be the most efficient way to capture keywords...

Self & "|" & gEnter

[Anuviel]

Thanks, so a global field that would capture word, you would have to enter one word by one word? From the reading of the calculation I gather that if I entered

blue bird

the calc would return

blue bird|

If I entered blue and then commit, then enter bird i would get

blue|bird

am I on the right track?

* Cannot test know, away from computer with FM...

[comment]

If there is always one space between the words, you can use Substitute() to replace it with a "|" (and perhaps TrimAll to remove excess spaces).

However, I agree with John that this is not the best method to enter multiple values. Separate records in a related table, or even a return-separated list would probably be better.

[Anuviel]

Thanks. Basically I have a one table file with about 10 fields total. It just serves as a point of data entry of information and then generates tab delimited file which is then uploaded to the web.

So the users enter information such as cost, item name, keywords and description.

The issue is that keywords need to be uploaded in the mentioned format of | after each keyword without spaces between them.

As you asked, yes, there will be one space after each word (not counting user input error of typing two spaces instead of one when entering words).

They want a simple way where they just want to go in and type the keywords all at once, on the fly, so to speak.

I was not sure how to go about it but I might make a related table or the return-separated list.

What would be recommended way to go considering the above mentioned?

One more thing, it is not important to keep the data for later use once the export file was generated, if that makes a difference.

[comment]

It doesn't matter much, except in terms of reliability (a list, whether return-separated or portal, makes errors more visible, IMHO).

[Anuviel]

Thanks. Will go with the list.

Thank for the help.