Finance | Project Operations, Human Resources, ...

hfunction in Visual Studio to separate string

(0) Share

Report

Posted on by @rp@n

hi all,

i have string like

value = "1222502-00000023-001-001";

is there any function in Visual Studio to separate string in below format ??

a = 00000023;
b = 001;
c = 001;

i have required this function for SSRS report

please give me more shed on this,

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can use the x++ string functions to achieve that: docs.microsoft.com/.../xpp-string-run-time-functions

You can use strFind to find a specific character from a string (or from part of a string).

And you can use subStr to copy a part of a string to another string.

You need three pieces of code:

a: All characters after the first "-" and before the second "-"

b: All characters after the second "-" and before the third "-"

c: All characters after the third "-"

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,095 on at

Like (1)

Report
Copy link

Link copied!

Hi @rp@n,

There is 'Split' function available in SSRS expressions.

stackoverflow.com/.../ssrs-expression-to-split-string-possible

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

Sergei,

i have to display in 3 columns the values in below format

a = 00000023;

b = 001;

c = 001

i have used

split(Fields!Dimension.Value,"-"),

but in report it's showing [tag:Error]

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi @rp@n,

Have you checked StackOverflow article with examples?

=Split(Fields!Dimension.Value, "-").GetValue(0) //First value

=Split(Fields!Dimension.Value, "-").GetValue(1) //Second

=Split(Fields!Dimension.Value, "-").GetValue(2)

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

hi Sergei,

it's work for me

=Split(Fields!Dimension.Value, "-").GetValue(1) //First value

=Split(Fields!Dimension.Value, "-").GetValue(2) //Second

=Split(Fields!Dimension.Value, "-").GetValue(3)

means here the

value = "1222502-00000023-001-001";

1222502 = 0

00000023 = 1

001 = 2

001 = 3

So, based on the above expression it's pick the value 1 position value after "-" i.e 00000023

rite?

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi @rp@n,

It's correct.

Split "Returns a zero-based, one-dimensional array containing a specified number of substrings."

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

is it possible to remove the values from the column which coming as concatenate. because we already spitted values in 3 columns

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi @rp@n,

Probably you can just put empty expression for the column or remove it completely.

Was this reply helpful? Yes No