[Resolved] Breaking apart a string

dcjones

Hi all.

I have a SQL table with a feild that holds data in a string format.

example: 198934569

What would be the best method of displaying that string in the following format:

example: 1-989-3456-9

Is it possible.

Kind regards

Dereck

laserlight

Could be something like:

function formatStr($str) {
	return $str{0} . "-"
		. substr($str, 1, 3) . "-"
		. substr($str, 4, 4) . "-"
		. $str{8};
}

dcjones

Hi Laserlight,

Thanks for your reply, I will play with your code.

Kind regards, keep safe and well

Dereck

dcjones

Hi again,

more advive if you could.

The string held in the table has a possible two formats

first format = 1-902375-000-0
second format = 1-84334-00-0

is there a way of I could detect the first 2 digets in the string and then apply function1 to any string with "1-9" and then function2 with any string with "1-8".

Your code works great with the format in my original post and I thank you for that.

Kind regards,

Dereck

TheDefender

if(substr("182920290", 0, 2) == "18"){
// Do this format function if it's 18
} elseif(substr("182920290", 0, 2) == "19"){
// Do this format function if it's 19
}

You could just do an if/else instead of the elseif, but with the elseif, you could keep adding to it if you need to should you find yourself needing more formatting options based on digits.

dcjones

Hi all,

Thanks to "laserlight" and "TheDefender" for thier help with this post.

Solution.

Function provided by "laserlight"

function formatStr1($str) { 
    return $str{0} . " " 
        . substr($str, 1, 5) . " " 
        . substr($str, 6, 3) . " " 
        . $str{9}; 
}

function formatStr2($str) { 
    return $str{0} . "-" 
        . substr($str, 1, 6) . "-" 
        . substr($str, 7, 2) . "-" 
        . $str{9}; 
}

Code provided by "TheDefender"


			if(substr("182920290", 0, 2) == "18"){
			echo formatStr1($row_record_filter['isbn_paperback']);
			} elseif(substr("182920290", 0, 2) == "19"){
			echo formatStr2($row_record_filter['isbn_paperback']);
			}

Many thanks to both of you.

Job done.

Kind regards, keep safe and well.

Dereck