Query, that remove blank spaces

[Pontos]

Hi!

In my table are numbers like: 099 200 001, 099 200 002,...
I need to make query on that field, that eliminates blank spaces betwen numbers (099 200 001 --> 099200001).

Rok

 

[SydneyGeek]

I tried this on a dummy system, and it worked for me:

NewCode: Replace([SplitCode]," ","",1,2,0) where [SplitCode] is the field that you want to remove the spaces from.

Denis

 

[Pontos]

Thankx!

The query works.
Maybe just quick explanation of the code.
What does the last part of code do (1,2,0)?

Rok

 

[SydneyGeek]

Here's an explanation of the syntax:

Replace («stringexpr», «find», «replace», «start», «count», «compare»)

Where
stringexpr = the starting string or field value
find = text value / string to search for
replace = replacement string / text value
start = starting position in stringexpr (1 to begin at first character)
count = # of occurrences to replace (2 in this case)
compare = method used for comparisons (0 is use database defaults)

Denis

 

[Pontos]

Thanks once again....