[Resolved] Exclude and re-order specific address information in view

[Author]

Posts

[Bob]

I'm trying to make a listing of resellers including their addresses. In my output the Country is always listed even though this is not relevant.

My questions:
• How to exclude the Country from the view results.
• Also I would like to be able to apply breaks in the output.

Current (fictional) output:
Mickey Mousestraat 15, Almere, Nederland

Preferred output:
Mickey Mousestraat 15
Almere

Thanks in advance,
Bob

[Minesh]

Hello. Thank you for contacting the Toolset support.

Well - this depends what field type you used to store your address value and how it's stored inside the database.

There is no way to exclude the country name from your address until we process your string in such way to delete the address value and format it according to your need.

You should have to split your string using comma and then build your required string. But I can guide you more once I can check your setup how the string is stored and where exactly you want to display it is said format.

Could you please send me problem URL where you want to display the address.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I would additionally need your permission to de- and re-activate Plugins and the Theme, and to change configurations on the site. This is also a reason the backup is really important. If you agree to this, please use the form fields I have enabled below to provide temporary access details (wp-admin and FTP).

I have set the next reply to private which means only you and I have access to it.

[Minesh]

I've added following custom shortcode to your current theme's functions.php file:

function func_display_address( $atts,$content) {
	 $a = shortcode_atts( array(
        'field' => '',
       ), $atts );
	   
	   $content = wpv_do_shortcode($content);
	   $content = explode(",",$content);
	  
	   
	   $val = '';
	   $count = count($content)-1;
	   
	   for($i=0;$i<$count;$i++){
			$val = $val.$content[$i]." <br/> ";
		}
	   return $val;
	   
    
}
add_shortcode( 'display_address', 'func_display_address' );

And I've called the shortcode as given under:

<td> [display_address][types field='adres-reseller'][/types][/display_address]</td>

And I can see now the Address is displayed as expected:
=> hidden link

[Bob]

Hey Minesh,

That's great! Thanks 🙂
When I sent you the login details, I also added some extra information, which I don't see in our conversation... The client I'm building this site for will be expanding abroad shortly, so actually the country name will be relevant after all 🙂

Whats changes need to be made to make it look like this:
Mickey Mousestraat 15
Almere, Nederland

Thanks again!

[Minesh]

Ok - I've modified the code as requested and added to your current theme's functions.php file:

function func_display_address( $atts,$content) {
	 $a = shortcode_atts( array(
        'field' => '',
       ), $atts );
	   
	   $content = wpv_do_shortcode($content);
	   $content = explode(",",$content);
	  
	   
	   $val = '';
	   $count = count($content);
	   
	   for($i=0;$i<$count;$i++){
 		  if($i%2===0){
			$val = $val.$content[$i]."<br/> ";
		  }else{
			  $val = $val.$content[$i].",";
		  }
		  
		}
	   return $val;
	   
    
}
add_shortcode( 'display_address', 'func_display_address' );

And I can see now the Address is displayed as expected:
=> hidden link

Could you please confirm 🙂

[Bob]

Thanks Minesh, you work wonders 🙂