Replacing "Not Assigned" value with Null ( Space).

[Former Member]

Hi ,

Can anyone tell me how to replace the "Not Assigned" value with Null ( Space).

Vishal

[former_member184494]

Vishal,

you can set the required values in TCODE RSCUSTV4 but this would be global across all reports

Arun

[Former Member]

Hi,

If u dont want not assigned value just exclude that, IF u want the not assigned values but u dont want to show it as not assigned then u can do that only way i.e. Create a routine in transfer rule while loading data saying that where if space is there for that char then take it as "Others".

For ex

IF ( TRAN_STRUCTURE-ZSERVICE_DESC EQ ' ' ).

RESULT = 'Others'.

ELSE.

RESULT = TRAN_STRUCTURE-ZSERVICE_DESC.

ENDIF.

Best Regards,

SG

[Former Member]

Hi

IF you want t oreplace you have to use VB macros...

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

'Find the Cells in Result Area and Change them

resultArea.Replace What:="#", Replacement:=" ", LookAt:= _

xlWhole, SearchOrder:=xlByRows, MatchCase:=True

End Sub

To delete # you can have option -->restrict --> and exclude from selection.

Cheers

Sunil

[Former Member]

Hi

IF you want t oreplace you have to use VB macros...

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

'Find the Cells in Result Area and Change them

resultArea.Replace What:="#", Replacement:=" ", LookAt:= _

xlWhole, SearchOrder:=xlByRows, MatchCase:=True

End Sub

To delete # you can have option -->restrict --> and exclude from selection.

Cheers

Sunil

[Former Member]

Hi

IF you want t oreplace you have to use VB macros...

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

'Find the Cells in Result Area and Change them

resultArea.Replace What:="#", Replacement:=" ", LookAt:= _

xlWhole, SearchOrder:=xlByRows, MatchCase:=True

End Sub

To delete # you can have option -->restrict --> and exclude from selection.

Cheers

Sunil

[Former Member]

Vishal,

It can be done in workbook but not in query. You can total exclude the # symbol in query but cannot show space in place of #. You can develop own logic to replace # with some other value using formulas but cannot replace it with space.

[Former Member]

Hi

IF you want t oreplace you have to use VB macros...

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)

'Find the Cells in Result Area and Change them

resultArea.Replace What:="#", Replacement:=" ", LookAt:= _

xlWhole, SearchOrder:=xlByRows, MatchCase:=True

End Sub

To delete # you can have option -->restrict --> and exclude from selection.

Cheers

Sunil