Thursday, June 16, 2011

Concatenate blank space

I had a setback in concatenating blank spaces in between variables/fields.
My case scenario. I have 10 fields. Need to concatenate them all. However, lets say for field6, 7, and 8, i would like them to have spaces in between when concatenated. For the rest of the fields, no space is needed when concatenated together.

How i solved:
Solution found here: http://forums.sdn.sap.com/thread.jspa?threadID=1323937
I declared a variable eg: v_space type C value ' '.
The space in between the apostrophes is done via pressing buttons ALT 2 5 5...and magically creates a blank space in between the apostrophes.

1 comment:

  1. Tableau Data Visualization Software
    SQIAR (http://www.sqiar.com/solutions/technology/tableau) is a leading Business Intelligence company and provides Tableau Software consultancy across United Kingdom and USA.

    ReplyDelete